package com.apes.enquiry.product.repository;

import com.apes.enquiry.product.model.OilyProduct;
import com.apes.framework.jpa.repository.CustomRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

/**
 * 类描述：
 *
 * @ClassName TyreExtendRepository
 * @Description 描述
 * @Author lilong
 * @Date 2022/10/31 14:04
 * @Version 1.0
 */
public interface OilyProductRepository extends CustomRepository<OilyProduct,String> {

    @Query(value = "SELECT * FROM  sp_mas_oily_product T  where T.sp_id=:id",nativeQuery = true)
    OilyProduct findBySpId(@Param("id") String id);
}
